package com.bw.mapper;

import com.bw.bean.Gm;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
* @author 联想
* @description 针对表【gm】的数据库操作Mapper
* @createDate 2024-11-01 09:05:22
* @Entity com.bw.bean.Gm
*/
@Mapper
public interface GmMapper {
    List<Gm> getlist();
    List<Gm> getlimit();
    List<Gm> getName(String name);
    @Select("SELECT gm.values from gm ORDER BY gm.values")
    List<Gm> getsx();
    @Select("SELECT m.values from gm m,gp p,my y WHERE m.id=y.mid and p.id=y.pid ORDER BY m.values desc")
    List<Gm> jx();
}




